Automation of order costing analysis by using Visual Basic for applications in Microsoft Excel

In the modern world of technologies (sciences arts), optimum operation time is prime consideration. Technologies with greater are needed to be modified or replaced as per requirement current scenario. small and medium enterprises developing countries, almost all reporting activities conducted in Microsoft Excel. The manual Excel takes a long (17.37 minutes, only if there was one order article color) users; furthermore, can also chance error report. same way, costing report at ABC footwear company Lahore prepared manually which used take along probability errors Because above-mentioned reasons, decided automated help visual basic for applications (VBA) procedure including collected from planning department Company. Moreover, were listed down their study conducted. VBA macros programmed objectives automating tasks eliminating (calculation made by employee). Macros, use conditional statements, (i.e. else conditions) various types loops, Do while loop loop). Automated decisions statements during circulated loops across whole worksheet. Two userforms designed execution click command buttons (having back). Total eight worksheets incorporated into template. All explained flowcharts Visio. After automated, operations performed after each stop watch. data obtained entered so that old suggested methods could compared. Comparison both indicated method took 85.92% less compared preparing At time, free workload employees reduced.